package com.ruoyi.web.controller.common;

import java.io.FileWriter;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.alibaba.fastjson2.JSONObject;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.CollectionUtils;
import com.ruoyi.common.core.domain.entity.SysDictData;
import com.ruoyi.common.core.domain.entity.SysDictType;
import com.ruoyi.common.core.domain.model.TransInfo;
import com.ruoyi.common.core.redis.RedisCache;
import com.ruoyi.system.coretools.TranslateDriver;
import com.ruoyi.system.domain.SysFileInfo;
import com.ruoyi.system.mapper.SysDictDataMapper;
import com.ruoyi.system.mapper.SysDictTypeMapper;
import com.ruoyi.system.service.ISysFileInfoService;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.http.MediaType;
import org.springframework.validation.annotation.Validated;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;
import com.ruoyi.common.config.RuoYiConfig;
import com.ruoyi.common.constant.Constants;
import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.common.utils.StringUtils;
import com.ruoyi.common.utils.file.FileUploadUtils;
import com.ruoyi.common.utils.file.FileUtils;
import com.ruoyi.framework.config.ServerConfig;

/**
 * 通用请求处理
 *
 * @author ruoyi
 */
@RestController
@RequestMapping("/common")
public class CommonController {
    private static final Logger log = LoggerFactory.getLogger(CommonController.class);

    @Autowired
    private ServerConfig serverConfig;
    @Autowired
    private ISysFileInfoService sysFileInfoService;

    private static final String FILE_DELIMETER = ",";

    @Autowired
    TranslateDriver translateDriver;

    @Autowired
    private RedisCache redisCache;
    @Autowired
    private SysDictDataMapper sysDictDataMapper;

    /**
     * 获取通用语言列表
     */
    @GetMapping("/getLangList")
    public AjaxResult getLangList(HttpServletResponse response, HttpServletRequest request) {
        try {

            AjaxResult ajax = AjaxResult.success();
            ajax.put("langList", ExcelLangReader.getLangList());
            return ajax;

        } catch (Exception e) {
            log.error("获取支持的语言列表失败!", e);
        }
        return AjaxResult.error();
    }


    /**
     * 翻译一种文字到语言，极少让前台用到(测试用)
     */
    @PostMapping("/queryTranslate")
    public AjaxResult addTranslate(@Validated @RequestBody TransInfo transInfo, HttpServletResponse response, HttpServletRequest request) {
        try {

            AjaxResult ajax = AjaxResult.success();

           /* String result = translateDriver.callTranslate(transInfo.getSourceLanguage(), transInfo.getTargetLanguage(), transInfo.getSourceText());

            translateDriver.saveLangPool(transInfo.getSourceText(), transInfo.getTargetLanguage(), result, 3);*/

            translateDriver.saveLangPoolWapper(transInfo);

            String result = translateDriver.getLangPoolByRedis(transInfo.getSourceText(), transInfo.getTargetLanguage());

            ajax.put("transResult", result);
            return ajax;

        } catch (Exception e) {
            log.error("获取支持的语言列表失败!", e);
        }
        return AjaxResult.error();
    }


    /**
     * 翻译一种文字到语言，极少让前台用到(测试用)
     */
    @PostMapping("/queryTranslateByKeyValuesBy20")
    public JSONObject queryTranslateByKeyValuesBy20(@Validated @RequestBody Map<String, String> jsonMap, HttpServletResponse response, HttpServletRequest request) {
        try {
            //AjaxResult ajax = AjaxResult.success();
            LambdaQueryWrapper<SysDictData> wrapper = new LambdaQueryWrapper<>();
            ArrayList<String> types = new ArrayList<String>();
            types.add("lang_list");
            wrapper.in(!CollectionUtils.isEmpty(types), SysDictData::getDictType, types);
            List<SysDictData> list = sysDictDataMapper.selectList(wrapper);

            for (SysDictData sysDictData : list) {

                String targetLanguage = sysDictData.getDictValue();//jsonMap.get("targetLanguage").toString()//"targetLanguage":"en",

                JSONObject jsonObject = new JSONObject();
                for (String key : jsonMap.keySet()) {
                    if (jsonMap.get(key) != null) {
                        String value = translateDriver.callTranslate("zh", targetLanguage, jsonMap.get(key).toString());
                        jsonObject.put(key, value);
                    }
                }
                log.info(jsonObject.toJSONString());

                FileWriter fileWriter = new FileWriter("C:\\fanyi\\" + targetLanguage + "-Hans.json");
                fileWriter.write(jsonObject.toJSONString());

                //return jsonObject;
            }

        } catch (Exception e) {
            log.error("获取支持的语言列表失败!", e);
        }
        return null;
    }


    @PostMapping("/queryTranslateByKeyValuesBy1")
    public JSONObject queryTranslateByKeyValuesBy1(@Validated @RequestBody Map<String, String> jsonMap, HttpServletResponse response, HttpServletRequest request) {
        JSONObject jsonObject = new JSONObject();
        try {

            //String targetLanguage = sysDictData.getDictValue();//jsonMap.get("targetLanguage").toString()//"targetLanguage":"en",
            String targetLanguage=jsonMap.get("targetLanguage").toString();

            for (String key : jsonMap.keySet()) {
                if (jsonMap.get(key) != null) {
                    String value = translateDriver.callTranslate("zh", targetLanguage, jsonMap.get(key).toString());
                    jsonObject.put(key, value);
                }
            }
            log.info(jsonObject.toJSONString());

            FileWriter fileWriter = new FileWriter("C:\\fanyi\\" + targetLanguage + "-Hans.json");
            fileWriter.write(jsonObject.toJSONString());
            fileWriter.close();

            //return jsonObject;


        } catch (Exception e) {
            log.error("获取支持的语言列表失败!", e);
        }
        return jsonObject;
    }

    /**
     * 通用下载请求
     *
     * @param fileName 文件名称
     * @param delete   是否删除
     */
    @GetMapping("/download")
    public void fileDownload(String fileName, Boolean delete, HttpServletResponse response, HttpServletRequest request) {
        try {
            if (!FileUtils.checkAllowDownload(fileName)) {
                throw new Exception(StringUtils.format("文件名称({})非法，不允许下载。 ", fileName));
            }
            String realFileName = System.currentTimeMillis() + fileName.substring(fileName.indexOf("_") + 1);
            String filePath = RuoYiConfig.getDownloadPath() + fileName;

            response.setContentType(MediaType.APPLICATION_OCTET_STREAM_VALUE);
            FileUtils.setAttachmentResponseHeader(response, realFileName);
            FileUtils.writeBytes(filePath, response.getOutputStream());
            if (delete) {
                FileUtils.deleteFile(filePath);
            }


        } catch (Exception e) {
            log.error("下载文件失败", e);
        }
    }


    /**
     * 单独删除接口（避免下载后在删除的多余浪费宽带动作）
     *
     * @param fileName 文件名称
     */
    @GetMapping("/fileDelete")
    public void fileDelete(String fileName, HttpServletResponse response, HttpServletRequest request) {
        try {
            if (!FileUtils.checkAllowDownload(fileName)) {
                throw new Exception(StringUtils.format("文件名称({})非法，不允许删除。 ", fileName));
            }
            String filePath = RuoYiConfig.getDownloadPath() + fileName;

            FileUtils.deleteFile(filePath);
        } catch (Exception e) {
            log.error("删除文件失败", e);
        }
    }


    /**
     * body form-data file:q.png
     * {
     * "msg": "操作成功",
     * "fileName": "/profile/upload/2024/04/23/ff_20240423185858A001_5157c4dd-129c-49a5-b64d-7b14bb7a1b89.png",
     * "code": 200,
     * "newFileName": "ff_20240423185858A001_5157c4dd-129c-49a5-b64d-7b14bb7a1b89.png",
     * "url": "http://localhost:8080/profile/upload/2024/04/23/ff_20240423185858A001_5157c4dd-129c-49a5-b64d-7b14bb7a1b89.png",
     * "originalFilename": "test.png"
     * }
     * 通用上传请求（单个）
     */
    @PostMapping("/upload")
    public AjaxResult uploadFile(MultipartFile file) throws Exception {
        try {
            // 上传文件路径
            String filePath = RuoYiConfig.getUploadPath();
            // 上传并返回新文件名称
            String fileName = FileUploadUtils.upload(filePath, file);
            String url = serverConfig.getUrl() + fileName;
            AjaxResult ajax = AjaxResult.success();
            ajax.put("url", url);
            ajax.put("fileName", fileName);
            ajax.put("newFileName", FileUtils.getName(fileName));
            ajax.put("originalFilename", file.getOriginalFilename());


            //完了后数据入库
            SysFileInfo sysFileInfo = new SysFileInfo();
            sysFileInfo.setFileName(fileName);
            sysFileInfo.setFilePath(filePath);
            sysFileInfo.setFileExtension(FileUploadUtils.getExtension(file));
            sysFileInfoService.insertSysFileInfo(sysFileInfo);
            log.info("数据库入库了文件上传:{}", sysFileInfo.getFileName());


            return ajax;
        } catch (Exception e) {
            return AjaxResult.error(e.getMessage());
        }
    }

    /**
     * 通用上传请求（多个）
     */
    @PostMapping("/uploads")
    public AjaxResult uploadFiles(List<MultipartFile> files) throws Exception {
        try {
            // 上传文件路径
            String filePath = RuoYiConfig.getUploadPath();
            List<String> urls = new ArrayList<String>();
            List<String> fileNames = new ArrayList<String>();
            List<String> newFileNames = new ArrayList<String>();
            List<String> originalFilenames = new ArrayList<String>();
            for (MultipartFile file : files) {
                // 上传并返回新文件名称
                String fileName = FileUploadUtils.upload(filePath, file);
                String url = serverConfig.getUrl() + fileName;
                urls.add(url);
                fileNames.add(fileName);
                newFileNames.add(FileUtils.getName(fileName));
                originalFilenames.add(file.getOriginalFilename());


                //完了后数据入库
                SysFileInfo sysFileInfo = new SysFileInfo();
                sysFileInfo.setFileName(FileUtils.getName(fileName));
                sysFileInfo.setFilePath(filePath);
                sysFileInfo.setFileExtension(FileUploadUtils.getExtension(file));
                sysFileInfoService.insertSysFileInfo(sysFileInfo);
                log.info("数据库入库了文件上传:{}", sysFileInfo.getFileName());


            }
            AjaxResult ajax = AjaxResult.success();
            ajax.put("urls", StringUtils.join(urls, FILE_DELIMETER));
            ajax.put("fileNames", StringUtils.join(fileNames, FILE_DELIMETER));
            ajax.put("newFileNames", StringUtils.join(newFileNames, FILE_DELIMETER));
            ajax.put("originalFilenames", StringUtils.join(originalFilenames, FILE_DELIMETER));
            return ajax;
        } catch (Exception e) {
            return AjaxResult.error(e.getMessage());
        }
    }

    /**
     * 本地资源通用下载
     */
    @GetMapping("/download/resource")
    public void resourceDownload(String resource, HttpServletRequest request, HttpServletResponse response)
            throws Exception {
        try {
            if (!FileUtils.checkAllowDownload(resource)) {
                throw new Exception(StringUtils.format("资源文件({})非法，不允许下载。 ", resource));
            }
            // 本地资源路径
            String localPath = RuoYiConfig.getProfile();
            // 数据库资源地址
            String downloadPath = localPath + StringUtils.substringAfter(resource, Constants.RESOURCE_PREFIX);
            // 下载名称
            String downloadName = StringUtils.substringAfterLast(downloadPath, "/");
            response.setContentType(MediaType.APPLICATION_OCTET_STREAM_VALUE);
            FileUtils.setAttachmentResponseHeader(response, downloadName);
            FileUtils.writeBytes(downloadPath, response.getOutputStream());
        } catch (Exception e) {
            log.error("下载文件失败", e);
        }
    }
}
